شرح شغل

5+ year experience as a SQL server DBA (SQL 2012, 2016, 2019) which includes HADR Scenarios (Distributed Availability Group, Availability Group, Failover Cluster Instance, Mirroring and etc.)Conduct Database failure mode analysis, develop and test recovery procedures, and invoke failover and DR plans when required.Architect and Maintain services including data modeling, storage, message brokers, protocols, interfaces and etc.Analyze Servers/Instances/Databases issues and troubleshoot database platform problems, and drive short- and long-term corrective actions, and platform improvement plansPrototype and design the multiple layers of Database platform in the lab, including the HW, Firmware, OS, DB server, HA and Data replication.Perform upgrades and security patches to databases as required.Define and maintain the Database key performance indices, system health thresholds, and known issues list to enable the NOC for monitoring and incident triggeringDatabase performance tuning (Instance and server level)Database disaster recovery planning and testingDatabase security administrationMonitor database performance to ensure high levels of security and speedExpert understanding of SQL query execution and advanced scripting in Batch, T-SQLExperience implementing ETL workflowsMaintain and extend (as required) existing database operations solution for backups, index defragmentation, data retention, etc.Collaborate with software and DevOps engineers to design scalable services, plan feature roll-out, and ensure high reliability and performance of our products.Provide service and support determined by the current Service Level Agreements, including 24 x 7 rotational on-call support for production databases.